﻿#region
//Copyright (c) 2016-2022 北京网非科技有限公司(wfdot.com)
//
//Permission is hereby granted, free of charge, to any person obtaining a copy
//of this software and associated documentation files (the "Software"), to deal
//in the Software without restriction, including without limitation the rights
//to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
//copies of the Software, and to permit persons to whom the Software is
//furnished to do so, subject to the following conditions:
//
//The above copyright notice and this permission notice shall be included in
//all copies or substantial portions of the Software.
//
//THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
//IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
//FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
//AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
//LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
//OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
//THE SOFTWARE.
#endregion
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SumiaAccountBook.DataAccess
{
    public static class DaSum
    {
        public static List<Entity.ProjectSum> GetCashFlowList(int accountBookId, DateTime startDate, DateTime endDate)
        {
            List<Entity.ProjectSum> list = new List<Entity.ProjectSum>();
            using (CommonContext<Entity.CashFlow> db = new CommonContext<Entity.CashFlow>())
            {
                var records = db.All;

                //根据查询条件拼lamda表达式
                var query = records.AsQueryable();
                query = query.Where(r => r.AccountBookId == accountBookId);
                if (null != startDate && startDate != DateTime.MinValue)
                {
                    query = query.Where(r => r.Date >= startDate);                    
                }
                if (null != endDate && endDate != DateTime.MinValue)
                {
                    query = query.Where(r => r.Date <= endDate);
                }
                var tmpGroup = query.GroupBy(r => new { Id = r.ProjectId, type = r.Type }).
                    Select(group => new { projectId = group.Key.Id, type = group.Key.type, sum = group.Sum(g => g.Amount) });
                foreach (var g in tmpGroup)
                {
                    if (g.projectId>0)
                    {
                        list.Add(new Entity.ProjectSum { ProjectId = g.projectId, Type = g.type, Total = g.sum });
                    }                    
                }
                return list;
            }
        }

        public static List<Entity.ProjectSum> GetCurrentList(int[] projectIds)
        {
            List<Entity.ProjectSum> list = new List<Entity.ProjectSum>();
            using (CommonContext<Entity.Current> db = new CommonContext<Entity.Current>())
            {                
                var query = from p in db.All
                          where (projectIds).Contains(p.ProjectId)
                          select p;
                var tmpGroup = query.GroupBy(r => new { Id = r.ProjectId, type = r.Type }).
                    Select(group => new { projectId = group.Key.Id, type = group.Key.type, sum = group.Sum(g => g.Amount) });
                foreach (var g in tmpGroup)
                {
                    list.Add(new Entity.ProjectSum { ProjectId = g.projectId, Type = g.type, Total = g.sum });
                }
            }
            return list;
        }
    }
}
